47/57

# orch.disconnect

Disconnects the local R session from Oracle Database.

Usage

    orch.disconnect(
            silent,
            dbcon)

Arguments

silent

  Set to `TRUE` to suppress all messages, or `FALSE` to see them (default).

dbcon

  Set to `TRUE` to display the connection details, or `FALSE` to suppress this information (default).

Usage Notes

No `orch` functions work without a connection to Oracle Database.

Return Value

An Oracle Database connection object when `dbcon` is `TRUE`, otherwise `NULL`

See Also

`orch.connect`

Example

This example disconnects the local R session from Oracle Database:

    R> orch.disconnect()
    Disconnected from a database.

The next example disconnects the local R session from Oracle Database and displays the returned connection object:

    R> oid<-orch.disconnect(silent=TRUE, dbcon=TRUE)
    R> oid
    Object of class "orch.dbcon"
    data frame with 0 columns and 0 rows
    slow "ok":
    [1] TRUE

    Slot "host":
    [1] "localhost"

    Slow "port":
    [1] 1521

    Slot "sid":
    [1] orcl

    Slot "user":
    [1] RQUSER

    Slot "passwd":
    [1] ""

    Slot "secure":
    [1] TRUE

    Slot "drv":
    [1] "sqoop"